hi,

want to send an email two ice a day, from database.
so i have planned to make a storedproce which will be called by
a job (which will select some record from one table and put it in other table based on a flag)
but i want to run it in a transaction so that if email is send successfully
then only it should commit else it should rollback.

q1) how  can i find that "Mail queued" now i should commit.

q2) if there is any other way to solve the problem , then please tel me. (will ssis be better than above one)
your sincerely

• Edited by rajemessage 13 hours 36 minutes ago

The problem is imho "sent succesfully". Even if sent successfully, it does not necessarily mean that it will arrive at the recipients.

Hi,

Please check if this link give you the answer:
Check the Status of E-Mail Messages Sent With Database Mail

Hello,

You can get the information from System view sysmail_allitems (Transact-SQL) in sys database "msdb".